OLAP PivotTable Extensions is a niche publisher that focuses exclusively on extending the analytical power of Microsoft Excel for business-intelligence professionals who work with multidimensional data. Its single flagship add-in deepens the native PivotTable experience by injecting a layer of fine-grained control over Analysis Services cubes, the Excel Data Model created by Power Pivot, and live connections to Power BI datasets. Typical use cases include finance teams that need to override default cube formats, marketing analysts who want to inject custom calculated members on the fly, and data stewards who must trace MDX query strings or expose hidden measure groups without leaving the worksheet. The tool surfaces in a task pane, letting users add calculated measures, rename hierarchies, apply dynamic security expressions, or capture the underlying MDX for debugging—all operations that normally require BI developer tools. Because the extension writes nothing back to the cube, IT governance is preserved while power-user productivity rises. Versions track every Excel release from 2010 onward, installing either per-user or machine-wide through a lightweight MSI that respects corporate policy. The publisher’s software is available for free on get.nero.com, where downloads are supplied through trusted Windows package sources such as winget, always delivering the latest build and permitting batch installation alongside other applications.
An Excel add-in which extends the functionality of PivotTables on Analysis Services cubes, Excel Data Model (Power Pivot), and Power BI
Details